Mapping Gay/Lesbian Travel Guides¶
Jenny Li
Final Project for Data; May 2025
Disclaimer: AI was used for this project
Introduction¶
In the pre-internet era, LGBTQ+ individuals often relied on underground networks and printed resources to safely navigate social life, travel, and public spaces. One of the most important of these resources was Gaia’s Guide, a printed travel guide that cataloged bars, bookstores, community centers, and other establishments that were considered safe or affirming for gay and lesbian travelers. In an era when being openly queer could lead to harassment, arrest, or worse, such guides played a vital role in both survival and community building.
Accoding to the article from Taylor & Francis; Gaia’s Guide was created by Sandy Horn, an American lesbian activist. She published the first edition in 1974, initially titled The Girl’s Guide to International Living, which was later renamed Gaia’s Guide in 1975. She have independently produced and distributed the guide for approximately 18 years, continuing until shortly before her death in 1993. At the same time she have also received data informations for different states through travelers, and compilling it into Gaia's guide.
This project explores a digitized and geocoded dataset of listings originally featured in Gaia’s Guide. The goal is to uncover spatial and cultural patterns in how LGBTQ+ spaces were distributed and categorized in the United States across different time periods. Specifically, we focus on identifying where bars and restaurants—often the social hubs of queer life—were located, and how these locations varied across states.
Questions explored include:
-Which states had the most gay and lesbian bars listed?
-What were the most common types of LGBTQ+ establishments?
-How were these spaces geographically distributed across the U.S.?
This data-driven mapping project aims to illustrate patterns of visibility, concentration, and types of queer spaces during a period when LGBTQ+ people were often marginalized in public life.
import pandas as pd
official_df = pd.read_csv('guide-geocoded.csv')
official_df
| title | description | type | address | city | state | country | publication | year | notes | geocode.value | lon | lat | geoAddress | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gay Liberation | NaN | Organizations | P.O Box 1614;35201 | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 1 | The Outer Focus | Tel. 254-9488 | Bars | 117 21st North | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 2 | "Gismo's" | NaN | Bars | 209 South 22nd St. | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 3 | The Matador | NaN | Bars | 208 North 22nd St. | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 4 | The Red Room | Tel. 251-0171 | Bars | 2101 5th North | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 51608 | Erotic News | (Books) | Book Store,Erotic Shop | 1688 Locust St. | Walnut Creek | CA | United States | Bob Damron's Address Book | 1989 | NaN | Walnut Creek, CA, United States | -122.065182 | 37.910078 | walnut creek, ca, usa |
| 51609 | Hub | (Disco) (Some L) | Bars/Clubs | 1220 Pine St. | Walnut Creek | CA | United States | Bob Damron's Address Book | 1989 | NaN | Walnut Creek, CA, United States | -122.065182 | 37.910078 | walnut creek, ca, usa |
| 51610 | 'Rest Stop' | on Hwy 1 Vista Pt. nr. Mae Monte Dr. exit | Cruising Areas | NaN | Watsonville | CA | United States | Bob Damron's Address Book | 1989 | NaN | Watsonville, CA, United States | -121.756895 | 36.910231 | watsonville, ca, usa |
| 51611 | Scene One | (Disco) | Restaurant | 340 N. Azusa | West Covina | CA | United States | Bob Damron's Address Book | 1989 | NaN | West Covina, CA, United States | -117.938953 | 34.068621 | west covina, ca, usa |
| 51612 | Travel Adviosrs | NaN | Travel Agency | 20050 Ventura Blvd. | Woodland Hills | CA | United States | Bob Damron's Address Book | 1989 | NaN | Woodland Hills, CA, United States | -118.605827 | 34.168503 | woodland hills, los angeles, ca, usa |
51613 rows × 14 columns
print(official_df.sample(5))
title description \
8693 Carousel NaN
15430 'L' Street Beach NaN
44796 Downtown Airlines Bus Terminal basement
12609 The Boardwalk (at O' Street)-Tel. 474-9741
50649 Sequoia Park Zoo NaN
type address city state country \
8693 Bars 8 lonia,S.W Grand Rapids MI United States
15430 Cruising Areas NaN Boston MA United States
44796 Cruising Areas NaN San Francisco CA United States
12609 Bars 104 North 20th Lincoln NE United States
50649 Cruising Areas NaN Eureka CA United States
publication year notes \
8693 Gaia's Guide 1985 NaN
15430 Bob Damron's Address Book 1977 NaN
44796 Bob Damron's Address Book 1975 NaN
12609 Gaia's Guide 1989 NaN
50649 Bob Damron's Address Book 1989 NaN
geocode.value lon lat \
8693 Grand Rapids, MI, United States -85.668086 42.963360
15430 Boston, MA, United States -71.058880 42.360082
44796 San Francisco, CA, United States -122.419415 37.774929
12609 Lincoln, NE, United States -96.702576 40.813663
50649 Eureka, CA, United States -124.163673 40.802071
geoAddress
8693 grand rapids, mi, usa
15430 boston, ma, usa
44796 san francisco, ca, usa
12609 lincoln, ne, usa
50649 eureka, ca, usa
Methodology¶
The dataset used in this project is derived from Gaia's Guide, a series of travel guides published primarily in the 1970s through the early 2000s. These guides served as directories for LGBTQ+ travelers, listing bars, restaurants, bookstores, community centers, and organizations that were known to be welcoming to gay and lesbian individuals. The data itself likely originated through a combination of grassroots community submissions, word-of-mouth recommendations, personal travel experiences, and occasional business outreach.
These guides were often compiled by small activist publishers or LGBTQ+ organizations who received tips and recommendations from local residents or travelers. Locations included in Gaia’s Guide were chosen based on their perceived friendliness or safety for LGBTQ+ patrons in a time when discrimination, harassment, and exclusion were common.
For this project, a CSV file named guide-geocoded.csv was provided, which includes the digitized and geocoded version of this historical data. It contains variables such as the name and type of establishment, address, city, state, year of listing, and geolocation coordinates (latitude and longitude). The geocoding process was likely performed using tools such as the Google Maps API or geopy, which translated the textual addresses into geographic coordinates.
Once imported into Python using pandas, the dataset was cleaned and filtered to isolate only the entries from Gaia's Guide. From there, we conducted geographic and categorical analyses to explore trends—specifically focusing on bars and restaurants as culturally significant spaces for LGBTQ+ community formation.
gaia_df = official_df[official_df['publication'] == "Gaia's Guide"]
gaia_df
| title | description | type | address | city | state | country | publication | year | notes | geocode.value | lon | lat | geoAddress | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gay Liberation | NaN | Organizations | P.O Box 1614;35201 | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 1 | The Outer Focus | Tel. 254-9488 | Bars | 117 21st North | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 2 | "Gismo's" | NaN | Bars | 209 South 22nd St. | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 3 | The Matador | NaN | Bars | 208 North 22nd St. | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| 4 | The Red Room | Tel. 251-0171 | Bars | 2101 5th North | Birmingham | AL | United States | Gaia's Guide | 1975 | NaN | Birmingham, AL, United States | -86.810357 | 33.518589 | birmingham, al, usa |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 13461 | Double Decker | (downstairs); -Tel. 292-9381 | Bars | 181 Walnut Street | Morgantown | WV | United States | Gaia's Guide | 1989 | NaN | Morgantown, WV, United States | -79.955897 | 39.629526 | morgantown, wv, usa |
| 13462 | Grand Palace | -Tel. 342-9532 | Bar / Restaurants | 617 Brooks St | Charleston | WV | United States | Gaia's Guide | 1989 | NaN | Charleston, WV, United States | -81.632623 | 38.349820 | charleston, wv, usa |
| 13463 | Christian Support Group | PO Box 27; 26003 -Tel. 233-4121 | Religious Groups | PO Box 27 | Wheeling | WV | United States | Gaia's Guide | 1989 | NaN | Wheeling, WV, United States | -80.720915 | 40.063962 | wheeling, wv 26003, usa |
| 13464 | Metropolitan Community Church / Morgantown | -Tel. 292-3128. Mail to:\nPO Box 576; 26507 | Religious Groups | PO Box 576 | Morgantown | WV | United States | Gaia's Guide | 1989 | NaN | Morgantown, WV, United States | -79.955897 | 39.629526 | morgantown, wv, usa |
| 13465 | Grand Books | -write: Box 7424; 83001 -Tel. 733-1687. 'We ha... | Bookstores | 970 West Broadway | Jackson | WY | United States | Gaia's Guide | 1989 | NaN | Jackson, WY, United States | -110.762428 | 43.479929 | jackson, wy, usa |
13466 rows × 14 columns
To begin the analysis, I filtered the dataset to include only entries published in Gaia's Guide. This step ensures that the data reflects the specific scope of the project: mapping spaces that catered to lesbian travelers, as Gaia's Guide was one of the earliest and most influential travel guides created for lesbian audiences. While some venues included may also have served gay men or the broader LGBTQ+ community, the focus of this guide justifies narrowing the analysis in this way.
Types of Locations¶
type_counts = gaia_df['type'].value_counts().sort_values(ascending=False)
print("\nNumber of each venue type:")
print(type_counts)
Number of each venue type:
type
Bars 4784
Bar 716
Restaurants 622
Religious Groups 500
Publications 382
...
Gay/Lesbian Political Group 1
Bars[3X] 1
Organization/Center 1
Resort/Dsico 1
Services Center 1
Name: count, Length: 734, dtype: int64
import pandas as pd
import matplotlib.pyplot as plt
official_df = pd.read_csv('guide-geocoded.csv')
gaia_df = official_df[official_df['publication'] == "Gaia's Guide"]
type_counts = gaia_df['type'].value_counts().head(10)
plt.figure(figsize=(10, 10))
plt.pie(
type_counts,
labels=type_counts.index,
autopct='%1.1f%%',
startangle=140
)
plt.title("Top 10 Venue Types in Gaia's Guide")
plt.axis('equal')
plt.show()
This pie chart visualizes the distribution of different types of venues listed in Gaia’s Guide, a lesbian travel directory. Each slice represents a specific category such as bars, bookstores, community centers, or restaurants and the size of the slice corresponds to the number of times that venue type appears in the dataset.
As shown, bars account for a significant portion of the total listings. For many in the LGBTQ+ community, bars were some of the only spaces where they could feel seen and supported without fear of judgment or danger. The article from San Diego Pride explains how bars like The Rail and The Flame played huge roles in queer history by giving people a place to gather, celebrate, and organize. These bars weren’t just places to party, they are also safe zones, meeting spots for activism, and places where identity and pride were nurtured.
Numbers of Locations by State¶
In order to show the number of location in each state, first I filtered the dataset to include only rows where the venue type was labeled as “Bar” or “Bar / Restaurants.” Then, I grouped the data by state and counted how many entries appeared in each one. This gave me a clear picture of how these types of venues are distributed across the country.
bars_df = gaia_df[gaia_df['type'].str.contains("Bar", case=False, na=False)]
bars_by_state = bars_df['state'].value_counts().sort_index()
print("Number of bars in each state:")
print(bars_by_state)
Number of bars in each state: state AK 28 AL 84 AR 39 AZ 77 CA 795 CO 83 CT 86 DC 33 DE 23 FL 474 GA 106 HI 44 IA 51 ID 21 IL 251 IN 123 KS 67 KT 5 KY 50 LA 128 MA 244 MD 77 ME 46 MI 191 MN 46 MO 153 MS 24 MT 18 NC 99 ND 5 NE 49 NH 26 NJ 186 NM 34 NV 48 NY 539 OH 298 OK 75 OR 96 PA 284 PR 32 RI 56 SC 53 SD 9 TN 113 TX 313 UT 23 VA 59 VI 1 VT 12 Virgin Islands 1 WA 121 WI 128 WV 49 WY 16 Washington, D.C. 6 Name: count, dtype: int64
Above is a text-based output showing the number of bars in each state, sorted alphabetically.
import matplotlib.pyplot as plt
bars_df = gaia_df[gaia_df['type'].isin(['Bars', 'Bar / Restaurants'])]
state_counts = bars_df['state'].value_counts().sort_values(ascending=False)
plt.figure(figsize=(10, 6))
state_counts.plot(kind='bar', color='skyblue')
plt.title("Number of Bars/Restaurants in Each State (Gaia's Guide)")
plt.xlabel("State")
plt.ylabel("Number of Locations")
plt.xticks(rotation=45)
plt.tight_layout()
plt.show()
Secondly, this is a bar chart that shows the number of bars and bar/restaurants listed in Gaia’s Guide across different U.S. states. The states are displayed in descending order of location count, giving a clear view of regional concentration.
Unsurprisingly, California stands out with the highest number of venues, followed by New York, Florida, Texas, and Ohio. States with large urban populations and historically significant LGBTQ+ communities. This pattern suggests a correlation between population density, urbanization, and the visibility or accessibility of lesbian spaces during the time of the guide’s publication.
Interacting Maps¶
!pip install folium
Requirement already satisfied: folium in /opt/anaconda3/lib/python3.12/site-packages (0.19.5) Requirement already satisfied: branca>=0.6.0 in /opt/anaconda3/lib/python3.12/site-packages (from folium) (0.8.1) Requirement already satisfied: jinja2>=2.9 in /opt/anaconda3/lib/python3.12/site-packages (from folium) (3.1.4) Requirement already satisfied: numpy in /opt/anaconda3/lib/python3.12/site-packages (from folium) (1.26.4) Requirement already satisfied: requests in /opt/anaconda3/lib/python3.12/site-packages (from folium) (2.32.3) Requirement already satisfied: xyzservices in /opt/anaconda3/lib/python3.12/site-packages (from folium) (2022.9.0) Requirement already satisfied: MarkupSafe>=2.0 in /opt/anaconda3/lib/python3.12/site-packages (from jinja2>=2.9->folium) (2.1.3) Requirement already satisfied: charset-normalizer<4,>=2 in /opt/anaconda3/lib/python3.12/site-packages (from requests->folium) (3.3.2) Requirement already satisfied: idna<4,>=2.5 in /opt/anaconda3/lib/python3.12/site-packages (from requests->folium) (3.7) Requirement already satisfied: urllib3<3,>=1.21.1 in /opt/anaconda3/lib/python3.12/site-packages (from requests->folium) (2.2.3) Requirement already satisfied: certifi>=2017.4.17 in /opt/anaconda3/lib/python3.12/site-packages (from requests->folium) (2024.12.14)
import folium
bars_df = gaia_df[gaia_df['type'].str.contains("Bar", case=False, na=False)]
map_center = [bars_df['lat'].mean(), bars_df['lon'].mean()]
m= folium.Map(location=map_center, zoom_start=5)
for _, row in bars_df.iterrows():
popup = f"<b>{row['title']}</b><br>{row['address']}<br>{row['city']}, {row['state']}"
folium.Marker(
location=[row['lat'], row['lon']],
popup=popup,
icon=folium.Icon(color='blue', icon='glass', prefix='fa')
).add_to(m)
m
This interactive map uses Folium to visualize the geographical spread of bar and bar/restaurant venues listed in Gaia’s Guide. Each blue marker on the map represents a specific location, with pop-up information displaying the name, address, city, and state of the venue.
import folium
from folium.plugins import HeatMap
bars_df = gaia_df[gaia_df['type'].str.contains("Bar", case=False, na=False)]
heat_data = bars_df[['lat', 'lon']].dropna().values.tolist()
map_center = [bars_df['lat'].mean(), bars_df['lon'].mean()]
heat_map = folium.Map(location=map_center, zoom_start=5)
HeatMap(heat_data, radius=10).add_to(heat_map)
heat_map
Unlike the discrete marker map, the heat map emphasizes clustering patterns and urban density. We can clearly see strong concentrations in coastal urban centers like New York City, Los Angeles, and San Francisco, as well as secondary clusters in cities like Chicago, Atlanta, and Miami. These hotspots correspond with historically significant centers of LGBTQ+ community life and activism.
Conlusion¶
The data shows that bars and restaurants were the most frequently listed types of establishments in Gaia's Guide, reflecting the importance of nightlife and safe public gathering spaces in the LGBTQ+ community. Certain states such as California, New York, and Florida had the highest concentration of listings. These patterns reflect urban migration and visibility during the late 20th century queer movement.
The use of mapping and heatmaps helps to visualize safe queer geography and contributes to the archival documentation of queer culture in the U.S. By using data science tools, we make this history more accessible and analyzable.
One of the most striking insights from this analysis is the central role that bars and restaurants played in lesbian social life. They were not merely recreational venues, but vital hubs for community formation, political organizing, safety, and identity affirmation. The overwhelming dominance of bars in the venue type distribution underlines how nightlife was one of the few accessible and accepted public forums for lesbians during the late 20th century. At the same time, the relative scarcity of other types of spaces—such as health centers, bookstores, or community organizations—points to the limited range of formal infrastructure available to support lesbian life, particularly outside of major urban centers.
Bibliography¶
- "Mapping Gay Guides Project." UNC Digital Innovation Lab. https://mappingthegayguides.org
- Brown, Gavin. “Queer Memorials: Sexuality, Memory and Public Space.” Feminist Media Studies, vol. 20, no. 4, 2019, pp. 460–477, https://doi.org/10.1080/14680777.2019.1665569.
- Verdes, Nicole. “The Historical Importance of Bars to LGBTQIA+ Culture.” San Diego Pride, 2023, https://sdpride.org/the-historical-importance-of-bars-to-lgbtqia-culture/.